Please enable JavaScript.
Coggle requires JavaScript to display documents.
Power BI - Coggle Diagram
Power BI
-
-
-
-
5) Power query
-
b) what is power query
- data cleaning, data autiomation
and ETL
- insead of python for data cleaning
VBA micros for automation it would be easy to use power query
- for automation of your reports and daily repetative task.
-
-
-
-
-
-
12) Various Data Sources in Power BI (in everything we can schedule automatic backup and even I could make a app or software out of it)
- Get SQL data in power BI
- credentials, server name, database name
- Get Live website data in power BI
- how to pull data from Amazon, flipkart and wikipedia
- if we are pulling the data from website power bi can pull the data from first page smoothly but if we need data for all pages then we need to use Python, R script.
- ( case studies I can make stock market, share market, currency exchange ex. dollar value, rupee, pound value, gdp value from goverment website, data trend from few years. )
- get email data in power BI
- credit, debit card statements,salary slips, meeting invites, etc.
- get google forms (google sheets) data in power BI
- Get power BI dataset
- backend -> data cleaning/ data modeling part
- must be logging on power bi and power bi service account
- share point data in power bi
- data is always store on cloud platforms like azure, aws, sql server, onedrive or sharepoint etc. where you can store excel, csv, pdf, json etc files and so on. ( take the specific part of the url only)
- get JSON files in power bi
13) Working with filters and parameters
- introduction to working with filters, sorting and parameters.
- working with filters, parameters and sorting in power bi power query.
- filtering textual data
- filtering date
- filtering numbers
- sorting of data
- we do sorting on data source level, power query, power pivot and report view
- creating parameter
- connect parameter with dataset
when you directly search for number, text or PER or date it will create huge formulas and functions in the backend and it will create a huge load on dataset and it will reduce the performance so don't use typing and seraching better to use Text, number and date filter option and drop down in it. parameter is so much important
14) Custom function feature to clean and combine files
- Clean and combine csv files together
- step 1): Clean one CSV file
step2) create a parameter for file name
step3) connect the parameter with the data/file
step 4) Create a function for cleaned file ( mr. Rahul)
step 5) Bring all other files form the folder
step 6) Apply created functions on all files
- Clean and combine excel files in power bi power Query
(same steps as above as csv)
15) Finding out postal codes from states and UT's
- Finding out postal codes from states and UT's
- same steps as above in excel clean and combine files
16) Case Studies
- Introduction to Case Studies
- Get file names from a folder in power BI power query
- Cleaning Payroll data in power BI power query
- Clean Data and get discounts
- Split data in rows and columns in power bi
- changing Stacked address table (one above the other) in power BI power query( Pivot )
- cleaning and structuring the data
- Cleaning Bank financial data
- Technoedge Case study
- Pickup the latest file form the folder
- Matching records in two tables
- data can be in 2 different tables, sheets, files, data sources.
- Create Fiscal year calender
- Clean Bank statement Available in PDF
if you can clean and structure data then you can visualize and then analyze and can make the informed decision or could a quick decision making
17) Extra case studies
- Assigning scores to students
- structuring invoice data
- author book challenge
18) M Functions
- introduction M function
- M function date -lsln
- M function Date_Add and substract
- M function - Date - Basic
- M Function -Text
- Write a simple M code
- Trick to get help fo 800+ M functions
-
-
-