Why Excel or Google Sheet is important in Data Analytics

Excel or Google sheets are used by all organizations to keep the raw data, sales and many different type of records. A successful Excel spreadsheet will organize raw data into a readable format that makes it easier to extract actionable insights. With more complex data, Excel allows you to customize fields and functions that make calculations for you.

Excel provide commands, functions and tools that make your data analysis tasks easy. You can avoid many time consuming and/or complex calculations using Excel.

You can create graphs and can customize the records in an easier way. You can do automation using google sheets. You can write your own script to fetch data from Database. Many organizations use Excel files to catalog data sets, import data, create data models, and more.

Comments

ETL Process in Power BI

We can make a data analysis process easy using the ETL process in Power BI Desktop. What is ETL in Power BI Desktop ? ETL (Extract, Transform and Load) data is a process by which we can change the shape of our dataset. You can perform several operations in Power Query editor. During the ETL process, data is extracted from a data source (raw data), then transformed, corrected and then loaded for the next step. You can do this process manually in Excel but it is time consuming process and at the end of the day, we don't want to do the same process for upcoming new data. It should be done by automation. If you have not read my last blog on Power BI then please go through the link Blog We will start the ETL process step by step A. Extract Data B. Transform Data C. Load Data A. Extract Data from a data source To extract data from a data source, click on Get Data. We will extract raw data from Excel sheet and then will connect the sheet with Power BI. You can ext...

Get started with Power BI Desktop

The very first question comes in mind is Should I use Power BI Desktop or Power BI Service to create a dashboard ? You should get started with Power BI Desktop. As I have already told in the first blog ( Blog 1 ) that the flow of creating a report is Power BI Desktop > Power BI Service > Power BI Mobile

Introduction to Power BI

Microsoft Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Whether your data is a simple Microsoft Excel workbook, or a collection of cloud-based and on-premises hybrid data warehouses, Power BI lets you easily connect to your data sources, visualize (or discover) what's important, and share that with anyone or everyone. Data Connectors in Power BI Excel Sheet Text or CSV file XML or Json File SQL Server Database MySQL Database IBM Database Azure Database Google Big Query Google Analytics AWS Redshift ... etc. The Parts of Power BI Power BI consists of a Microsoft Windows desktop application called Power BI Desktop, an online SaaS (Software as a Service) service called the Power BI service, and mobile Power BI apps that are available on any device, with native mobile BI apps for Windows, iOS, and Android. Power BI Desktop Powe...

Meticlux

Search This Blog