๐5๐1
5 Steps to Learn Front-End Development๐
Step 1: Basics
โ Internet
โ HTTP
โ Browser
โ Domain & Hosting
Step 2: HTML
โ Basic Tags
โ Semantic HTML
โ Forms & Table
Step 3: CSS
โ Basics
โ CSS Selectors
โ Creating Layouts
โ Flexbox
โ Grid
โ Position - Relative & Absolute
โ Box Model
โ Responsive Web Design
Step 3: JavaScript
โ Basics Syntax
โ Loops
โ Functions
โ Data Types & Object
โ DOM selectors
โ DOM Manipulation
โ JS Module - Export & Import
โ Spread & Rest Operator
โ Asynchronous JavaScript
โ Fetching API
โ Event Loop
โ Prototype
โ ES6 Features
Step 4: Git and GitHub
โ Basics
โ Fork
โ Repository
โ Pull Repo
โ Push Repo
โ Locally Work With Git
Step 5: React
โ Components & JSX
โ List & Keys
โ Props & State
โ Events
โ useState Hook
โ CSS Module
โ React Router
โ Tailwind CSS
Now apply for the job. All the best ๐
Need Full stack web development course
Step 1: Basics
โ Internet
โ HTTP
โ Browser
โ Domain & Hosting
Step 2: HTML
โ Basic Tags
โ Semantic HTML
โ Forms & Table
Step 3: CSS
โ Basics
โ CSS Selectors
โ Creating Layouts
โ Flexbox
โ Grid
โ Position - Relative & Absolute
โ Box Model
โ Responsive Web Design
Step 3: JavaScript
โ Basics Syntax
โ Loops
โ Functions
โ Data Types & Object
โ DOM selectors
โ DOM Manipulation
โ JS Module - Export & Import
โ Spread & Rest Operator
โ Asynchronous JavaScript
โ Fetching API
โ Event Loop
โ Prototype
โ ES6 Features
Step 4: Git and GitHub
โ Basics
โ Fork
โ Repository
โ Pull Repo
โ Push Repo
โ Locally Work With Git
Step 5: React
โ Components & JSX
โ List & Keys
โ Props & State
โ Events
โ useState Hook
โ CSS Module
โ React Router
โ Tailwind CSS
Now apply for the job. All the best ๐
Need Full stack web development course
๐8โค2
100+ YouTube channels you should subscribe now:
โฏ HTML/CSS โ Kevin Powell
โฏ C โ Jacob Sorber
โฏ C++ โ TheCherno
โฏ Java โ Telusko
โฏ C# โ kudvenkat
โฏ Python โ Corey Schafer
โฏ JavaScript โ developedbyed
โฏ SQL โ Joey Blue
โฏ Golang โ Jon Calhoun
โฏ Swift โ CodeWithChris
โฏ Kotlin โ PhilippLackner
โฏ PHP โ ProgramWithGio
โฏ Ruby โ DriftingRuby
โฏ Rust โ NoBoilerplate
โฏ Lua โ Steve's teacher
โฏ Scala โ DevInsideYou
โฏ Julia โ TheJuliaLanguage
โฏ MATLAB โ Joseph Delgadillo
โฏ R โ marinstatlectures
โฏ C++ โ javidx9
โฏ C++ โ LearningLad
โฏ C++ โ Trevor Payne
โฏ JavaScript โ Akshay Saini
โฏ TypeScript โ basarat
โฏ TypeScript โ TypeScriptTV
โฏ C# โ Microsoft Developer [Bob Tabor]
โฏ C# โ dotnet [Scott/Kendra]
โฏ SQL โ The Magic of SQL
-- Frameworks --
โฏ Node.js โ Traversy Media
โฏ React โ Codevolution
โฏ React โ Dave Gray
โฏ React โ Jack Herrington
โฏ Next.js โ Lama Dev
โฏ Vue โ Vue Mastery
โฏ Svelte โ Joy of Code
โฏ Angular โ Angular University
โฏ Django โ CodingEntrepreneurs
โฏ Laravel โ LaravelDaily
โฏ Blazor โ James Montemagno
โฏ Spring โ SpringSourceDev
โฏ SpringBoot โ amigoscode
โฏ Ruby on Rails โ GorailsTV
-- Mobile App --
โฏ React Native โ Codevolution
โฏ React Native โ Hitesh Choudhary
โฏ Flutter โ The Flutter Way
โฏ Flutter โ Tadas Petra
-- DSA --
โฏ take U forward
โฏ mycodeschool
โฏ Abdul Bari
โฏ Kunal Kushwaha
โฏ Jenny's Lectures CS IT
โฏ CodeWithHarry
-- Full Stack --
โฏ Traversy Media
โฏ NetNinja
โฏ Dave Gray
โฏ Projects
โ WebDevSimplified
โ JavaScript King
โฏ UI Design
โ developedbyed
โ DesignCourse
-- DevOps --
โฏ GIT โ The Modern Coder
โฏ Linux โ Learn Linux TV
โฏ DevOps โ DevOpsToolkit
โฏ CI/CD โ TechWorld with Nana
โฏ Docker โ Bret Fisher
โฏ Kubernetes โ Kubesimplify
โฏ Microservices โ freeCodeCamp
โฏ Selenium โ edureka!
โฏ Playwright โ Jaydeep Karale
-- Cloud Computing --
โฏ AWS โ amazonwebservices
โฏ Azure โ Adam Marczak
โฏ GCP โ edureka!
โฏ Serverless โ Serverless
โฏ Jenkins โ DevOps Journey
โฏ Puppet โ simplilearn
โฏ Chef โ simplilearn
โฏ Ansible โ Learn Linux TV
-- Data Science --
โฏ Mathematics
โ 3Blue1Brown
โ ProfRobBob
โ Ghrist Math
โ Numberphile
โฏ Machine Learning
โ sentdex
โ DeepLearningAI
โ StatQuest
โฏ Excel
โ ExcelIsFun
โ Kevin Stratvert
โ Chandoo
โฏ Tableau โ Tableau Tim
โฏ PowerBI
โ Guy in a Cube
โ Chandoo
โฏ Data Science
โ Krish Naik
โ Leila Gharani
โ Socratica
โฏ Data Analyst
โ AlexTheAnalyst
โ Luke Barousse
โฏ Projects โ Ken Jee
-- Code Editors --
โฏ Vim โ ThePrimeagen
โฏ VS Code โ Visual Studio Code
โฏ Jupyter Notebook โ Corey Schafer
-- Special Mentions --
โฏ Programming in 100 Sec โ Fireship
โฏ Interviews โ NeetCode
-- Free Education --
โ freecodecamp
โ Simplilearn
โ edureka!
-- Most Valuable --
โ TechWithTim
โ programmingwithmosh
โ Traversy Media
โ BroCodez
โ thenewboston
โ Telusko
โ Derek Banas
โ CodeWithHarry
โ MySirG .com
โ TechWorld with Nana
โ KodeKloud
โฏ HTML/CSS โ Kevin Powell
โฏ C โ Jacob Sorber
โฏ C++ โ TheCherno
โฏ Java โ Telusko
โฏ C# โ kudvenkat
โฏ Python โ Corey Schafer
โฏ JavaScript โ developedbyed
โฏ SQL โ Joey Blue
โฏ Golang โ Jon Calhoun
โฏ Swift โ CodeWithChris
โฏ Kotlin โ PhilippLackner
โฏ PHP โ ProgramWithGio
โฏ Ruby โ DriftingRuby
โฏ Rust โ NoBoilerplate
โฏ Lua โ Steve's teacher
โฏ Scala โ DevInsideYou
โฏ Julia โ TheJuliaLanguage
โฏ MATLAB โ Joseph Delgadillo
โฏ R โ marinstatlectures
โฏ C++ โ javidx9
โฏ C++ โ LearningLad
โฏ C++ โ Trevor Payne
โฏ JavaScript โ Akshay Saini
โฏ TypeScript โ basarat
โฏ TypeScript โ TypeScriptTV
โฏ C# โ Microsoft Developer [Bob Tabor]
โฏ C# โ dotnet [Scott/Kendra]
โฏ SQL โ The Magic of SQL
-- Frameworks --
โฏ Node.js โ Traversy Media
โฏ React โ Codevolution
โฏ React โ Dave Gray
โฏ React โ Jack Herrington
โฏ Next.js โ Lama Dev
โฏ Vue โ Vue Mastery
โฏ Svelte โ Joy of Code
โฏ Angular โ Angular University
โฏ Django โ CodingEntrepreneurs
โฏ Laravel โ LaravelDaily
โฏ Blazor โ James Montemagno
โฏ Spring โ SpringSourceDev
โฏ SpringBoot โ amigoscode
โฏ Ruby on Rails โ GorailsTV
-- Mobile App --
โฏ React Native โ Codevolution
โฏ React Native โ Hitesh Choudhary
โฏ Flutter โ The Flutter Way
โฏ Flutter โ Tadas Petra
-- DSA --
โฏ take U forward
โฏ mycodeschool
โฏ Abdul Bari
โฏ Kunal Kushwaha
โฏ Jenny's Lectures CS IT
โฏ CodeWithHarry
-- Full Stack --
โฏ Traversy Media
โฏ NetNinja
โฏ Dave Gray
โฏ Projects
โ WebDevSimplified
โ JavaScript King
โฏ UI Design
โ developedbyed
โ DesignCourse
-- DevOps --
โฏ GIT โ The Modern Coder
โฏ Linux โ Learn Linux TV
โฏ DevOps โ DevOpsToolkit
โฏ CI/CD โ TechWorld with Nana
โฏ Docker โ Bret Fisher
โฏ Kubernetes โ Kubesimplify
โฏ Microservices โ freeCodeCamp
โฏ Selenium โ edureka!
โฏ Playwright โ Jaydeep Karale
-- Cloud Computing --
โฏ AWS โ amazonwebservices
โฏ Azure โ Adam Marczak
โฏ GCP โ edureka!
โฏ Serverless โ Serverless
โฏ Jenkins โ DevOps Journey
โฏ Puppet โ simplilearn
โฏ Chef โ simplilearn
โฏ Ansible โ Learn Linux TV
-- Data Science --
โฏ Mathematics
โ 3Blue1Brown
โ ProfRobBob
โ Ghrist Math
โ Numberphile
โฏ Machine Learning
โ sentdex
โ DeepLearningAI
โ StatQuest
โฏ Excel
โ ExcelIsFun
โ Kevin Stratvert
โ Chandoo
โฏ Tableau โ Tableau Tim
โฏ PowerBI
โ Guy in a Cube
โ Chandoo
โฏ Data Science
โ Krish Naik
โ Leila Gharani
โ Socratica
โฏ Data Analyst
โ AlexTheAnalyst
โ Luke Barousse
โฏ Projects โ Ken Jee
-- Code Editors --
โฏ Vim โ ThePrimeagen
โฏ VS Code โ Visual Studio Code
โฏ Jupyter Notebook โ Corey Schafer
-- Special Mentions --
โฏ Programming in 100 Sec โ Fireship
โฏ Interviews โ NeetCode
-- Free Education --
โ freecodecamp
โ Simplilearn
โ edureka!
-- Most Valuable --
โ TechWithTim
โ programmingwithmosh
โ Traversy Media
โ BroCodez
โ thenewboston
โ Telusko
โ Derek Banas
โ CodeWithHarry
โ MySirG .com
โ TechWorld with Nana
โ KodeKloud
๐17โค2
โพHANDWRITTEN NOTES โ๏ธ โพ๏ธ
๐บDATA STRUCTURE SHORT NOTES
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 1)
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 2)
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 3)
๐บDBMS (DATABASE MANAGEMENT SYSTEM)NOTES
๐บC PROGRAMMING SHORT NOTES
๐บDATA STRUCTURE SHORT NOTES
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 1)
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 2)
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 3)
๐บDBMS (DATABASE MANAGEMENT SYSTEM)NOTES
๐บC PROGRAMMING SHORT NOTES
Please open Telegram to view this post
VIEW IN TELEGRAM
๐2
Here are the detailed answers to each of the Power BI interview questions that have been asked at Infosys, TCS & Wipro:
1. How can you ensure that Power BI recognizes a specific column as a date column if it doesn't do so automatically?
- You can change the data type of the column in Power Query Editor or in the Data View. Select the column, then use the data type dropdown to select "Date" or "Date/Time."
2. Describe the process Power BI uses to handle large datasets exceeding the in-memory capacity.
- Power BI can handle large datasets by using techniques such as aggregations, incremental refresh, and DirectQuery mode. DirectQuery allows Power BI to query data directly from the source without loading it into memory, while aggregations can summarize data at a higher level to reduce the amount of data processed.
3. Can you explain the role of the Power BI service in the overall Power BI architecture?
- The Power BI service (PowerBI.com) is a cloud-based service that provides various features like sharing, collaboration, and dashboarding. It allows users to publish, share, and manage reports, create dashboards, and collaborate with others in their organization. It also supports data refresh, scheduled refreshes, and gateways to connect to on-premises data sources.
4. What are the key components of data modeling in Power BI?
- The key components of data modeling in Power BI include tables, relationships, measures, calculated columns, and hierarchies. Data modeling involves defining how data from different sources relates to each other and creating a model that supports analysis and reporting.
5. What is the purpose of the VertiPaq engine in Power BI?
- The VertiPaq engine is an in-memory columnar database engine used by Power BI to compress and store data efficiently. It allows for fast query performance by storing data in a highly compressed format and retrieving only the necessary columns for a given query.
6. How do you create a stacked area chart in Power BI?
- To create a stacked area chart, go to the Report View, select the data fields you want to visualize, and then choose the "Stacked Area Chart" option from the visualizations pane.
7. What is the difference between a clustered bar chart and a stacked bar chart?
- A clustered bar chart displays bars for each category grouped side by side, allowing for comparison between categories. A stacked bar chart, on the other hand, stacks the bars on top of each other, showing the total value while also displaying the contribution of each category to the total.
8. Explain the concept of role-based access control (RBAC) in Power BI.
- Role-based access control (RBAC) in Power BI allows administrators to define roles with specific permissions and assign users to these roles. This ensures that users only have access to the data and reports they are authorized to view, enhancing security and data governance.
9. What is a calculated column in Power BI, and how is it different from a measure?
- A calculated column is a column that is created using a DAX formula to add new data to a table in the data model. It is calculated row by row. A measure, however, is a DAX formula used to perform calculations on aggregated data, and its result can change depending on the context of the report or visualization.
10. How can you create and apply a custom data category in Power BI?
- You can create and apply a custom data category by selecting the column in the Data View or Power Query Editor, and then choosing the appropriate data category from the "Modeling" tab in the ribbon. Custom data categories can include geographic data, URLs, and other types.
11. What are the different methods to optimize data load performance in Power BI?
- Methods to optimize data load performance include using DirectQuery mode for real-time queries, reducing the number of columns and rows loaded into memory, using aggregations to summarize data, optimizing data transformations in Power Query, and leveraging incremental refresh for large datasets.
1. How can you ensure that Power BI recognizes a specific column as a date column if it doesn't do so automatically?
- You can change the data type of the column in Power Query Editor or in the Data View. Select the column, then use the data type dropdown to select "Date" or "Date/Time."
2. Describe the process Power BI uses to handle large datasets exceeding the in-memory capacity.
- Power BI can handle large datasets by using techniques such as aggregations, incremental refresh, and DirectQuery mode. DirectQuery allows Power BI to query data directly from the source without loading it into memory, while aggregations can summarize data at a higher level to reduce the amount of data processed.
3. Can you explain the role of the Power BI service in the overall Power BI architecture?
- The Power BI service (PowerBI.com) is a cloud-based service that provides various features like sharing, collaboration, and dashboarding. It allows users to publish, share, and manage reports, create dashboards, and collaborate with others in their organization. It also supports data refresh, scheduled refreshes, and gateways to connect to on-premises data sources.
4. What are the key components of data modeling in Power BI?
- The key components of data modeling in Power BI include tables, relationships, measures, calculated columns, and hierarchies. Data modeling involves defining how data from different sources relates to each other and creating a model that supports analysis and reporting.
5. What is the purpose of the VertiPaq engine in Power BI?
- The VertiPaq engine is an in-memory columnar database engine used by Power BI to compress and store data efficiently. It allows for fast query performance by storing data in a highly compressed format and retrieving only the necessary columns for a given query.
6. How do you create a stacked area chart in Power BI?
- To create a stacked area chart, go to the Report View, select the data fields you want to visualize, and then choose the "Stacked Area Chart" option from the visualizations pane.
7. What is the difference between a clustered bar chart and a stacked bar chart?
- A clustered bar chart displays bars for each category grouped side by side, allowing for comparison between categories. A stacked bar chart, on the other hand, stacks the bars on top of each other, showing the total value while also displaying the contribution of each category to the total.
8. Explain the concept of role-based access control (RBAC) in Power BI.
- Role-based access control (RBAC) in Power BI allows administrators to define roles with specific permissions and assign users to these roles. This ensures that users only have access to the data and reports they are authorized to view, enhancing security and data governance.
9. What is a calculated column in Power BI, and how is it different from a measure?
- A calculated column is a column that is created using a DAX formula to add new data to a table in the data model. It is calculated row by row. A measure, however, is a DAX formula used to perform calculations on aggregated data, and its result can change depending on the context of the report or visualization.
10. How can you create and apply a custom data category in Power BI?
- You can create and apply a custom data category by selecting the column in the Data View or Power Query Editor, and then choosing the appropriate data category from the "Modeling" tab in the ribbon. Custom data categories can include geographic data, URLs, and other types.
11. What are the different methods to optimize data load performance in Power BI?
- Methods to optimize data load performance include using DirectQuery mode for real-time queries, reducing the number of columns and rows loaded into memory, using aggregations to summarize data, optimizing data transformations in Power Query, and leveraging incremental refresh for large datasets.
๐2โค1
12. Can you outline the Power BI ecosystem and its major components?
- The Power BI ecosystem consists of Power BI Desktop, Power BI Service, Power BI Mobile, Power BI Report Server, and Power BI Embedded. Power BI Desktop is used for creating reports and dashboards, the Power BI Service is a cloud-based platform for sharing and collaboration, Power BI Mobile allows viewing reports on mobile devices, Power BI Report Server is for on-premises report deployment, and Power BI Embedded is for integrating Power BI reports into custom applications.
13. What is the difference between a dataflow and a dataset in Power BI?
- A dataflow is a collection of data transformation processes in Power BI that are reusable and can be shared across multiple reports and datasets. A dataset, on the other hand, is a single source of data created from one or more data sources that is used in Power BI reports and dashboards.
14. How does the DirectQuery mode work in Power BI, and when would you use it?
- DirectQuery mode allows Power BI to directly query the underlying data source in real-time without importing data into memory. This mode is useful when working with very large datasets, ensuring data is always up-to-date, and minimizing the amount of data loaded into memory.
15. How do you create a waterfall chart in Power BI?
- To create a waterfall chart, go to the Report View, select the data fields you want to visualize, and then choose the "Waterfall Chart" option from the visualizations pane. This type of chart shows the cumulative effect of sequential positive and negative values.
16. What are the advantages and disadvantages of using a scatter plot in Power BI?
- Advantages: Scatter plots can show the relationship between two numerical variables, highlight clusters and outliers, and reveal trends and correlations. Disadvantages: They can become cluttered with too many data points, making it hard to interpret, and may require additional context to understand the data fully.
17. Explain the concept of incremental refresh in Power BI.
- Incremental refresh allows Power BI to refresh only the data that has changed or been added since the last refresh, rather than reloading the entire dataset. This reduces the time and resources required for data refreshes, making it suitable for large datasets with frequent updates.
18. What is the purpose of the "Group By" feature in Power BI, and how is it used?
- The "Group By" feature in Power BI allows users to group rows in a table based on one or more columns and perform aggregations (e.g., sum, average) on the grouped data. It is used in the Power Query Editor to simplify and summarize data before loading it into the data model.
19. How can you handle time zone conversions in Power BI?
- Time zone conversions can be handled by using DAX functions to adjust date and time values based on the desired time zone. You can use functions like
20. What techniques can be used to reduce the file size of a Power BI report?
- Techniques to reduce file size include removing unnecessary columns and rows, using aggregations to summarize data, optimizing data transformations in Power Query, disabling or removing unused visuals, and reducing the number of visuals on a single report page.
21. Describe the different layers involved in Power BI architecture.
- The Power BI architecture consists of the following layers: Data Source Layer (connects to various data sources), Data Transformation Layer (uses Power Query to clean and transform data), Data Modeling Layer (defines relationships, calculated columns, and measures), Visualization Layer (creates reports and dashboards), and Service Layer (manages sharing, collaboration, and data refresh).
- The Power BI ecosystem consists of Power BI Desktop, Power BI Service, Power BI Mobile, Power BI Report Server, and Power BI Embedded. Power BI Desktop is used for creating reports and dashboards, the Power BI Service is a cloud-based platform for sharing and collaboration, Power BI Mobile allows viewing reports on mobile devices, Power BI Report Server is for on-premises report deployment, and Power BI Embedded is for integrating Power BI reports into custom applications.
13. What is the difference between a dataflow and a dataset in Power BI?
- A dataflow is a collection of data transformation processes in Power BI that are reusable and can be shared across multiple reports and datasets. A dataset, on the other hand, is a single source of data created from one or more data sources that is used in Power BI reports and dashboards.
14. How does the DirectQuery mode work in Power BI, and when would you use it?
- DirectQuery mode allows Power BI to directly query the underlying data source in real-time without importing data into memory. This mode is useful when working with very large datasets, ensuring data is always up-to-date, and minimizing the amount of data loaded into memory.
15. How do you create a waterfall chart in Power BI?
- To create a waterfall chart, go to the Report View, select the data fields you want to visualize, and then choose the "Waterfall Chart" option from the visualizations pane. This type of chart shows the cumulative effect of sequential positive and negative values.
16. What are the advantages and disadvantages of using a scatter plot in Power BI?
- Advantages: Scatter plots can show the relationship between two numerical variables, highlight clusters and outliers, and reveal trends and correlations. Disadvantages: They can become cluttered with too many data points, making it hard to interpret, and may require additional context to understand the data fully.
17. Explain the concept of incremental refresh in Power BI.
- Incremental refresh allows Power BI to refresh only the data that has changed or been added since the last refresh, rather than reloading the entire dataset. This reduces the time and resources required for data refreshes, making it suitable for large datasets with frequent updates.
18. What is the purpose of the "Group By" feature in Power BI, and how is it used?
- The "Group By" feature in Power BI allows users to group rows in a table based on one or more columns and perform aggregations (e.g., sum, average) on the grouped data. It is used in the Power Query Editor to simplify and summarize data before loading it into the data model.
19. How can you handle time zone conversions in Power BI?
- Time zone conversions can be handled by using DAX functions to adjust date and time values based on the desired time zone. You can use functions like
TIMEZONEOFFSET to calculate the difference between time zones and adjust the datetime values accordingly.20. What techniques can be used to reduce the file size of a Power BI report?
- Techniques to reduce file size include removing unnecessary columns and rows, using aggregations to summarize data, optimizing data transformations in Power Query, disabling or removing unused visuals, and reducing the number of visuals on a single report page.
21. Describe the different layers involved in Power BI architecture.
- The Power BI architecture consists of the following layers: Data Source Layer (connects to various data sources), Data Transformation Layer (uses Power Query to clean and transform data), Data Modeling Layer (defines relationships, calculated columns, and measures), Visualization Layer (creates reports and dashboards), and Service Layer (manages sharing, collaboration, and data refresh).
๐1
Practical interview question for an entry-level data analyst role in #Power_BI: along with answers !
Question: Data Modeling Case: You have sales data and customer data in separate tables. How would you model this data in Power BI to analyze customer purchase behavior?
๐ Load the Data: Import the sales data and customer data tables into Power BI.
๐ Establish Relationships: Identify the CustomerID as the common key between the two tables. In the "Model" view, create a relationship by connecting the CustomerID column from the Sales Data table to the CustomerID column in the Customer Data table.
๐ Data Structure:
Sales Data Table: Contains columns like SaleID, CustomerID, ProductID, SaleDate, and Amount.
Customer Data Table: Contains columns like CustomerID, CustomerName, Age, Gender, and Location.
๐ Create Visualizations:
Total Sales by Customer: A bar chart showing the total amount spent by each customer.
Sales Over Time: A line chart displaying sales trends over time for each customer.
Customer Demographics: Pie charts or bar charts illustrating sales distribution by customer age, gender, and location.
๐ Utilize DAX for Advanced Analysis: Create measures using DAX (Data Analysis Expressions) to calculate total sales and sales by specific customer attributes for deeper insights.
By following these steps, you can effectively model your data in Power BI to gain meaningful insights into customer purchase behavior.
Question: Data Modeling Case: You have sales data and customer data in separate tables. How would you model this data in Power BI to analyze customer purchase behavior?
๐ Load the Data: Import the sales data and customer data tables into Power BI.
๐ Establish Relationships: Identify the CustomerID as the common key between the two tables. In the "Model" view, create a relationship by connecting the CustomerID column from the Sales Data table to the CustomerID column in the Customer Data table.
๐ Data Structure:
Sales Data Table: Contains columns like SaleID, CustomerID, ProductID, SaleDate, and Amount.
Customer Data Table: Contains columns like CustomerID, CustomerName, Age, Gender, and Location.
๐ Create Visualizations:
Total Sales by Customer: A bar chart showing the total amount spent by each customer.
Sales Over Time: A line chart displaying sales trends over time for each customer.
Customer Demographics: Pie charts or bar charts illustrating sales distribution by customer age, gender, and location.
๐ Utilize DAX for Advanced Analysis: Create measures using DAX (Data Analysis Expressions) to calculate total sales and sales by specific customer attributes for deeper insights.
By following these steps, you can effectively model your data in Power BI to gain meaningful insights into customer purchase behavior.
In Tableau, Level of Detail (LOD) expressions allow you to control the granularity of aggregations. Power BI has similar functionalities through the use of DAX (Data Analysis Expressions). While Power BI doesn't have direct LOD expressions, you can achieve the same results using DAX functions. Here are some common scenarios and their DAX equivalents:
1. Fixed LOD Expressions:
In Tableau, a fixed LOD expression computes values at a specific granularity, independent of the visualization's granularity.
Tableau:
Power BI (DAX):
2. Include LOD Expressions:
An include LOD expression adds a specific dimension to the granularity of the existing view.
Tableau:
Power BI (DAX):
3. Exclude LOD Expressions:
An exclude LOD expression removes a specific dimension from the granularity of the existing view.
Tableau:
Power BI (DAX):
4. Row-level Calculations:
To perform calculations at the row level and then aggregate the result, you can use the SUMX function in DAX.
Tableau:
Power BI (DAX):
These DAX functions allow you to achieve similar results as Tableau's LOD expressions by giving you control over the context and granularity of calculations.
1. Fixed LOD Expressions:
In Tableau, a fixed LOD expression computes values at a specific granularity, independent of the visualization's granularity.
Tableau:
{ FIXED [Dimension1], [Dimension2]: SUM([Measure]) }
Power BI (DAX):
CALCULATE(SUM('Table'[Measure]), ALLEXCEPT('Table', 'Table'[Dimension1], 'Table'[Dimension2]))
2. Include LOD Expressions:
An include LOD expression adds a specific dimension to the granularity of the existing view.
Tableau:
{ INCLUDE [Dimension]: SUM([Measure]) }
Power BI (DAX):
CALCULATE(SUM('Table'[Measure]), ALL('Table'[Dimension]))
3. Exclude LOD Expressions:
An exclude LOD expression removes a specific dimension from the granularity of the existing view.
Tableau:
{ EXCLUDE [Dimension]: SUM([Measure]) }
Power BI (DAX):
CALCULATE(SUM('Table'[Measure]), REMOVEFILTERS('Table'[Dimension]))
4. Row-level Calculations:
To perform calculations at the row level and then aggregate the result, you can use the SUMX function in DAX.
Tableau:
SUM([Measure1] + [Measure2])
Power BI (DAX):
SUMX('Table', 'Table'[Measure1] + 'Table'[Measure2])
These DAX functions allow you to achieve similar results as Tableau's LOD expressions by giving you control over the context and granularity of calculations.
๐4๐1
โพHANDWRITTEN NOTES โ๏ธ โพ๏ธ
๐บDATA STRUCTURE SHORT NOTES
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 1)
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 2)
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 3)
๐บDBMS (DATABASE MANAGEMENT SYSTEM)NOTES
๐บC PROGRAMMING SHORT NOTES
๐บDATA STRUCTURE SHORT NOTES
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 1)
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 2)
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 3)
๐บDBMS (DATABASE MANAGEMENT SYSTEM)NOTES
๐บC PROGRAMMING SHORT NOTES
Please open Telegram to view this post
VIEW IN TELEGRAM
๐2
My YOUTUBE HANDLE-
https://youtu.be/BSAh7nCzYyQ?si=ENogZEVFY_XawsNK
https://youtu.be/BSAh7nCzYyQ?si=ENogZEVFY_XawsNK
Follow karke rakho..Future me kuch bhi help chaye to Ya dosti hi rakhni ho to !!
Please open Telegram to view this post
VIEW IN TELEGRAM
๐1
*You can learn ReactJS easily ๐คฉ*
Here's all you need to get started ๐
1.Components
โข Functional Components
โข Class Components
โข JSX (JavaScript XML) Syntax
2.Props (Properties)
โข Passing Props
โข Default Props
โข Prop Types
3.State
โข useState Hook
โข Class Component State
โข Immutable State
4.Lifecycle Methods (Class Components)
โข componentDidMount
โข componentDidUpdate
โข componentWillUnmount
5.Hooks (Functional Components)
โข useState
โข useEffect
โข useContext
โข useReducer
โข useCallback
โข useMemo
โข useRef
โข useImperativeHandle
โข useLayoutEffect
6.Event Handling
โข Handling Events in Functional Components
โข Handling Events in Class Components
7.Conditional Rendering
โข if Statements
โข Ternary Operators
โข Logical && Operator
8.Lists and Keys
โข Rendering Lists
โข Keys in React Lists
9.Component Composition
โข Reusing Components
โข Children Props
โข Composition vs Inheritance
10.Higher-Order Components (HOC)
โข Creating HOCs
โข Using HOCs for Reusability
11.Render Props
โข Using Render Props Pattern
12.React Router
โข <BrowserRouter>
โข <Route>
โข <Link>
โข <Switch>
โข Route Parameters
13.Navigation
โข useHistory Hook
โข useLocation Hook
State Management
14.Context API
โข Creating Context
โข useContext Hook
15.Redux
โข Actions
โข Reducers
โข Store
โข connect Function (React-Redux)
16.Forms
โข Handling Form Data
โข Controlled Components
โข Uncontrolled Components
17.Side Effects
โข useEffect for Data Fetching
โข useEffect Cleanup
18.AJAX Requests
โข Fetch API
โข Axios Library
Error Handling
19.Error Boundaries
โข componentDidCatch (Class Components)
โข ErrorBoundary Component (Functional
Components)
20.Testing
โข Jest Testing Framework
โข React Testing Library
21. Best Practices
โข Code Splitting
โข PureComponent and React.memo
โข Avoiding Reconciliation
โข Keys for Dynamic Lists
22.Optimization
โข Memoization
โข Profiling and Performance Monitoring
23. Build and Deployment
โข Create React App (CRA)
โข Production Builds
โข Deployment Strategies
Frameworks and Libraries
24.Styling Libraries
โข Styled-components
โข CSS Modules
25.State Management Libraries
โข Redux
โข MobX
26.Routing Libraries
โข React Router
โข Reach Router
Here's all you need to get started ๐
1.Components
โข Functional Components
โข Class Components
โข JSX (JavaScript XML) Syntax
2.Props (Properties)
โข Passing Props
โข Default Props
โข Prop Types
3.State
โข useState Hook
โข Class Component State
โข Immutable State
4.Lifecycle Methods (Class Components)
โข componentDidMount
โข componentDidUpdate
โข componentWillUnmount
5.Hooks (Functional Components)
โข useState
โข useEffect
โข useContext
โข useReducer
โข useCallback
โข useMemo
โข useRef
โข useImperativeHandle
โข useLayoutEffect
6.Event Handling
โข Handling Events in Functional Components
โข Handling Events in Class Components
7.Conditional Rendering
โข if Statements
โข Ternary Operators
โข Logical && Operator
8.Lists and Keys
โข Rendering Lists
โข Keys in React Lists
9.Component Composition
โข Reusing Components
โข Children Props
โข Composition vs Inheritance
10.Higher-Order Components (HOC)
โข Creating HOCs
โข Using HOCs for Reusability
11.Render Props
โข Using Render Props Pattern
12.React Router
โข <BrowserRouter>
โข <Route>
โข <Link>
โข <Switch>
โข Route Parameters
13.Navigation
โข useHistory Hook
โข useLocation Hook
State Management
14.Context API
โข Creating Context
โข useContext Hook
15.Redux
โข Actions
โข Reducers
โข Store
โข connect Function (React-Redux)
16.Forms
โข Handling Form Data
โข Controlled Components
โข Uncontrolled Components
17.Side Effects
โข useEffect for Data Fetching
โข useEffect Cleanup
18.AJAX Requests
โข Fetch API
โข Axios Library
Error Handling
19.Error Boundaries
โข componentDidCatch (Class Components)
โข ErrorBoundary Component (Functional
Components)
20.Testing
โข Jest Testing Framework
โข React Testing Library
21. Best Practices
โข Code Splitting
โข PureComponent and React.memo
โข Avoiding Reconciliation
โข Keys for Dynamic Lists
22.Optimization
โข Memoization
โข Profiling and Performance Monitoring
23. Build and Deployment
โข Create React App (CRA)
โข Production Builds
โข Deployment Strategies
Frameworks and Libraries
24.Styling Libraries
โข Styled-components
โข CSS Modules
25.State Management Libraries
โข Redux
โข MobX
26.Routing Libraries
โข React Router
โข Reach Router
๐2โค1
Basic web development roadmap
๐ง
1.Learn: How websites work, front-end vs back-end, code editorโโ
๐ง
2: Basic front-end:
a. Html
b. Css
c. Javascript
Expected time 7+14+30=51 days.
๐ง
3. Learn front-end frameworks:
a. Learn css framework ( Bootstrap , Tailwind css , ...)
b. Learn JavaScript frameworks ( angular, react , vue...)
Expected time minimum 60 days.
๐ง
4. Learn database
a. MySQL
b. MongoDB
There are many more. Choose one and learn.
๐ง
5. Learn backend programming languages:
a. Php
b. Nodejs
There are many more. Learn any one.
Expected time: 60 days
๐ง
6. Do some projects and clone some websites.
โซ๏ธโซ๏ธ๐งโซ๏ธโซ๏ธ
๐ง
1.Learn: How websites work, front-end vs back-end, code editorโโ
๐ง
2: Basic front-end:
a. Html
b. Css
c. Javascript
Expected time 7+14+30=51 days.
๐ง
3. Learn front-end frameworks:
a. Learn css framework ( Bootstrap , Tailwind css , ...)
b. Learn JavaScript frameworks ( angular, react , vue...)
Expected time minimum 60 days.
๐ง
4. Learn database
a. MySQL
b. MongoDB
There are many more. Choose one and learn.
๐ง
5. Learn backend programming languages:
a. Php
b. Nodejs
There are many more. Learn any one.
Expected time: 60 days
๐ง
6. Do some projects and clone some websites.
โซ๏ธโซ๏ธ๐งโซ๏ธโซ๏ธ
๐3
Here's a short roadmap to crack an IT job with a non-CS background ๐
1. ๐ Learn basics of CS and programming.
2. ๐ฏ Choose a specialization (e.g., web dev, data analysis).
3. ๐ Complete online courses and certifications.
4. ๐ ๏ธ Build a portfolio of projects.
5. ๐ค Network with professionals.
6. ๐ผ Seek internships for experience.
7. ๐ Keep learning and stay updated.
8. ๐ง Develop soft skills.
9. ๐ Prepare for interviews.
10. ๐ช Stay persistent and positive! Good luck!
1. ๐ Learn basics of CS and programming.
2. ๐ฏ Choose a specialization (e.g., web dev, data analysis).
3. ๐ Complete online courses and certifications.
4. ๐ ๏ธ Build a portfolio of projects.
5. ๐ค Network with professionals.
6. ๐ผ Seek internships for experience.
7. ๐ Keep learning and stay updated.
8. ๐ง Develop soft skills.
9. ๐ Prepare for interviews.
10. ๐ช Stay persistent and positive! Good luck!
๐3โค1
๐๐ถ๐ ๐๐ ๐๐ถ๐๐๐๐ฏ: What's the Difference?
Ever mixed up Git and GitHub? Youโre not aloneโtheyโre related but serve distinct purposes!
๐๐ข๐ญ: A powerful version control system that tracks changes in your code. Itโs your local toolkit for managing versions, rolling back changes, and collaborating.
๐๐ข๐ญ๐๐ฎ๐: A cloud-based platform that hosts Git repositories online. It enhances collaboration by letting you share, review, and manage codeโthink of it as a social network for developers.
In short:
Git = Local version control tool
GitHub = Cloud-based hosting service for Git repositories
Understanding the difference can significantly improve your workflow and collaboration in software development!
Ever mixed up Git and GitHub? Youโre not aloneโtheyโre related but serve distinct purposes!
๐๐ข๐ญ: A powerful version control system that tracks changes in your code. Itโs your local toolkit for managing versions, rolling back changes, and collaborating.
๐๐ข๐ญ๐๐ฎ๐: A cloud-based platform that hosts Git repositories online. It enhances collaboration by letting you share, review, and manage codeโthink of it as a social network for developers.
In short:
Git = Local version control tool
GitHub = Cloud-based hosting service for Git repositories
Understanding the difference can significantly improve your workflow and collaboration in software development!
๐1
What Is MERN?
MERN Stack is a Javascript Stack that is used for easier and faster deployment of full-stack web applications. MERN Stack comprises of 4 technologies namely: MongoDB, Express, React and Node.js. It is designed to make the development process smoother and easier.
MongoDB
MongoDb is a NoSQL DBMS where data is stored in the form of documents having key-value pairs similar to JSON objects. MongoDB enables users to create databases, schemas and tables.
ExpressJS
ExpressJS is a NodeJS framework that simplifies writing the backend code. It saves you from creating multiple Node modules.
ReactJS
ReactJS is a JS library that allows the development of user interfaces for mobile apps and SPAs. It allows you to code Javascript and develop UI components.
NodeJS
NodeJS is an open-source Javascript runtime environment that allows users to run code on the server.
MERN Stack is a Javascript Stack that is used for easier and faster deployment of full-stack web applications. MERN Stack comprises of 4 technologies namely: MongoDB, Express, React and Node.js. It is designed to make the development process smoother and easier.
MongoDB
MongoDb is a NoSQL DBMS where data is stored in the form of documents having key-value pairs similar to JSON objects. MongoDB enables users to create databases, schemas and tables.
ExpressJS
ExpressJS is a NodeJS framework that simplifies writing the backend code. It saves you from creating multiple Node modules.
ReactJS
ReactJS is a JS library that allows the development of user interfaces for mobile apps and SPAs. It allows you to code Javascript and develop UI components.
NodeJS
NodeJS is an open-source Javascript runtime environment that allows users to run code on the server.
๐3
โพHANDWRITTEN NOTES โ๏ธ โพ๏ธ
๐บDATA STRUCTURE SHORT NOTES
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 1)
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 2)
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 3)
๐บDBMS (DATABASE MANAGEMENT SYSTEM)NOTES
๐บC PROGRAMMING SHORT NOTES
๐บDATA STRUCTURE SHORT NOTES
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 1)
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 2)
๐บDATA STRUCTURE
INTERVIEW SERIES ๐น(PART - 3)
๐บDBMS (DATABASE MANAGEMENT SYSTEM)NOTES
๐บC PROGRAMMING SHORT NOTES
Please open Telegram to view this post
VIEW IN TELEGRAM
ยฉHow fresher can get a job as a data scientist?ยฉ
Job market is highly resistant to hire data scientist as a fresher. Everyone out there asks for at least 2 years of experience, but then the question is where will we get the two years experience from?
The important thing here to build a portfolio. As you are a fresher I would assume you had learnt data science through online courses. They only teach you the basics, the analytical skills required to clean the data and apply machine learning algorithms to them comes only from practice.
Do some real-world data science projects, participate in Kaggle competition. kaggle provides data sets for practice as well. Whatever projects you do, create a GitHub repository for it. Place all your projects there so when a recruiter is looking at your profile they know you have hands-on practice and do know the basics. This will take you a long way.
All the major data science jobs for freshers will only be available through off-campus interviews.
Some companies that hires data scientists are:
Siemens
Accenture
IBM
Cerner
Creating a technical portfolio will showcase the knowledge you have already gained and that is essential while you got out there as a fresher and try to find a data scientist job.
Job market is highly resistant to hire data scientist as a fresher. Everyone out there asks for at least 2 years of experience, but then the question is where will we get the two years experience from?
The important thing here to build a portfolio. As you are a fresher I would assume you had learnt data science through online courses. They only teach you the basics, the analytical skills required to clean the data and apply machine learning algorithms to them comes only from practice.
Do some real-world data science projects, participate in Kaggle competition. kaggle provides data sets for practice as well. Whatever projects you do, create a GitHub repository for it. Place all your projects there so when a recruiter is looking at your profile they know you have hands-on practice and do know the basics. This will take you a long way.
All the major data science jobs for freshers will only be available through off-campus interviews.
Some companies that hires data scientists are:
Siemens
Accenture
IBM
Cerner
Creating a technical portfolio will showcase the knowledge you have already gained and that is essential while you got out there as a fresher and try to find a data scientist job.
๐3โค1
Some useful PYTHON libraries for data science
NumPy stands for Numerical Python. The most powerful feature of NumPy is n-dimensional array. This library also contains basic linear algebra functions, Fourier transforms, advanced random number capabilities and tools for integration with other low level languages like Fortran, C and C++
SciPy stands for Scientific Python. SciPy is built on NumPy. It is one of the most useful library for variety of high level science and engineering modules like discrete Fourier transform, Linear Algebra, Optimization and Sparse matrices.
Matplotlib for plotting vast variety of graphs, starting from histograms to line plots to heat plots.. You can use Pylab feature in ipython notebook (ipython notebook โpylab = inline) to use these plotting features inline. If you ignore the inline option, then pylab converts ipython environment to an environment, very similar to Matlab. You can also use Latex commands to add math to your plot.
Pandas for structured data operations and manipulations. It is extensively used for data munging and preparation. Pandas were added relatively recently to Python and have been instrumental in boosting Pythonโs usage in data scientist community.
Scikit Learn for machine learning. Built on NumPy, SciPy and matplotlib, this library contains a lot of efficient tools for machine learning and statistical modeling including classification, regression, clustering and dimensionality reduction.
Statsmodels for statistical modeling. Statsmodels is a Python module that allows users to explore data, estimate statistical models, and perform statistical tests. An extensive list of descriptive statistics, statistical tests, plotting functions, and result statistics are available for different types of data and each estimator.
Seaborn for statistical data visualization. Seaborn is a library for making attractive and informative statistical graphics in Python. It is based on matplotlib. Seaborn aims to make visualization a central part of exploring and understanding data.
Bokeh for creating interactive plots, dashboards and data applications on modern web-browsers. It empowers the user to generate elegant and concise graphics in the style of D3.js. Moreover, it has the capability of high-performance interactivity over very large or streaming datasets.
Blaze for extending the capability of Numpy and Pandas to distributed and streaming datasets. It can be used to access data from a multitude of sources including Bcolz, MongoDB, SQLAlchemy, Apache Spark, PyTables, etc. Together with Bokeh, Blaze can act as a very powerful tool for creating effective visualizations and dashboards on huge chunks of data.
Scrapy for web crawling. It is a very useful framework for getting specific patterns of data. It has the capability to start at a website home url and then dig through web-pages within the website to gather information.
SymPy for symbolic computation. It has wide-ranging capabilities from basic symbolic arithmetic to calculus, algebra, discrete mathematics and quantum physics. Another useful feature is the capability of formatting the result of the computations as LaTeX code.
Requests for accessing the web. It works similar to the the standard python library urllib2 but is much easier to code. You will find subtle differences with urllib2 but for beginners, Requests might be more convenient.
Additional libraries, you might need:
os for Operating system and file operations
networkx and igraph for graph based data manipulations
regular expressions for finding patterns in text data
BeautifulSoup for scrapping web. It is inferior to Scrapy as it will extract information from just a single webpage in a run.
NumPy stands for Numerical Python. The most powerful feature of NumPy is n-dimensional array. This library also contains basic linear algebra functions, Fourier transforms, advanced random number capabilities and tools for integration with other low level languages like Fortran, C and C++
SciPy stands for Scientific Python. SciPy is built on NumPy. It is one of the most useful library for variety of high level science and engineering modules like discrete Fourier transform, Linear Algebra, Optimization and Sparse matrices.
Matplotlib for plotting vast variety of graphs, starting from histograms to line plots to heat plots.. You can use Pylab feature in ipython notebook (ipython notebook โpylab = inline) to use these plotting features inline. If you ignore the inline option, then pylab converts ipython environment to an environment, very similar to Matlab. You can also use Latex commands to add math to your plot.
Pandas for structured data operations and manipulations. It is extensively used for data munging and preparation. Pandas were added relatively recently to Python and have been instrumental in boosting Pythonโs usage in data scientist community.
Scikit Learn for machine learning. Built on NumPy, SciPy and matplotlib, this library contains a lot of efficient tools for machine learning and statistical modeling including classification, regression, clustering and dimensionality reduction.
Statsmodels for statistical modeling. Statsmodels is a Python module that allows users to explore data, estimate statistical models, and perform statistical tests. An extensive list of descriptive statistics, statistical tests, plotting functions, and result statistics are available for different types of data and each estimator.
Seaborn for statistical data visualization. Seaborn is a library for making attractive and informative statistical graphics in Python. It is based on matplotlib. Seaborn aims to make visualization a central part of exploring and understanding data.
Bokeh for creating interactive plots, dashboards and data applications on modern web-browsers. It empowers the user to generate elegant and concise graphics in the style of D3.js. Moreover, it has the capability of high-performance interactivity over very large or streaming datasets.
Blaze for extending the capability of Numpy and Pandas to distributed and streaming datasets. It can be used to access data from a multitude of sources including Bcolz, MongoDB, SQLAlchemy, Apache Spark, PyTables, etc. Together with Bokeh, Blaze can act as a very powerful tool for creating effective visualizations and dashboards on huge chunks of data.
Scrapy for web crawling. It is a very useful framework for getting specific patterns of data. It has the capability to start at a website home url and then dig through web-pages within the website to gather information.
SymPy for symbolic computation. It has wide-ranging capabilities from basic symbolic arithmetic to calculus, algebra, discrete mathematics and quantum physics. Another useful feature is the capability of formatting the result of the computations as LaTeX code.
Requests for accessing the web. It works similar to the the standard python library urllib2 but is much easier to code. You will find subtle differences with urllib2 but for beginners, Requests might be more convenient.
Additional libraries, you might need:
os for Operating system and file operations
networkx and igraph for graph based data manipulations
regular expressions for finding patterns in text data
BeautifulSoup for scrapping web. It is inferior to Scrapy as it will extract information from just a single webpage in a run.
๐6โค1