Skip to main content

Posts

Showing posts from 2021

Excel for Data Analysis

 Most important functions of Excel for data analysis Excel and google sheets are powerful tools for managing the raw data. There are many functions that can make your task easier.  As a Data Analyst, you use many functions like VLOOKUP, Pivot Tables, Conditional formatting, etc., So here, I have listed some most important functions of excel for data analysis : - 1. Pivot Table Pivot tables are a way to aggregate data to look at smaller subsets without using manual filters. Without it, you would use the manual filters on every column, check to see if they work, and then use [SUM] functions. All of that is built for you with a pivot table and pivot chart. You can set rows, columns, values and filters at the same at your level. You can use any aggregate function while creating a Pivot table.  In short, Pivot table gives you the summary of your data. We will see more detail in next blog. 2. VLOOKUP VLOOKUP stands for "Vertical Lookup", this means the act of looking up da...

Power BI Quiz 1

Quiz 1 : Basics of Power BI and Data Analytics

Data Modelling in Power BI

  Modelling is a process to get your connected data for visualization. Basically, in modelling, you will connect to multiple data sources to create your reports.   Now the question is "How to connect multiple data sources to create a report?"  So, the answer is "You can create a relationship to create a logical connection between different data sources". A relationship enables Power BI to connect tables to one another so that you can create reports. How to Create a Data Relationship? The Model view in Power BI Desktop allows you to visually set the relationship between tables or elements. A relationship is where two or more tables are linked together with one or more join key(s) because they contain related data. In the Model view, notice that a block represents each table and the lines between them represent relationships. Adding and removing relationships is straightforward. To remove a relationship, right-click the relationship and select Delete . To create a r...

Power BI in Jupyter Notebook

 There is a good news from Microsoft Power BI. Now you can use Power BI in Jupyter Notebook. You can get your Power BI analytics in a Jupyter notebook with the new powerbiclient Python package. Now you can embed Power BI reports, dashboards, dashboard tiles, etc., in Jupyter notebooks easily. You’ll be able to export data from visuals in a Power BI report to the Jupyter notebook for in-depth data exploration. You can also filter the report for quick analysis or use bookmarks to apply a saved view. You can install the Power BI Client for Jupyter from PyPI and find the open-sourced Python package and associate TypeScript widget on GitHub . Install the package using pip: pip install powerbiclient Open your notebook and add the following: Import Report class and models from the package : from powerbiclient import Report, models Authenticate against Power BI using Azure AD : # Import the DeviceCodeLoginAuthentication class to authenticate against Power BI from powerbiclient.authen...

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.

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

Sign up and get Power BI account

  Power BI Desktop is free for creating a report or dashboard. You can connect any data source which is present in the Data Source List. But if you want to publish the report then you should have a Power BI account.  You can't create a power BI account with the Gmail. You can only create an account with work email address. 👎 If you have any work or college email then you can create an account for free.  You can also take free trial of Pro Power BI account for 60 days.😀 Steps to create Power BI account To get a free trial, follow these steps  Step - 1:   Go to Power BI Page    app.powerbi.com  ðŸ‘ˆ Step - 2:  If you are a new user then click on "Try Free" button Step - 3:  Now new tab will open in your browser and will ask to Sign Up with a work email.  Step - 4:   Now click on Yes  Step - 5:  Fill up the form and click on Start button After that Microsoft will ask to invite your colleagues but you can ...

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...