Data Analyst (Batch-08) Certification Program – Zero to Hero in Excel, SQL, Power BI, Tableau and Python

Categories: MS Excel, Power BI, Python, SQL, Tableau
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Data analysis is a process of inspecting, cleansing, transforming, and modelling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.

 

Data analysts are in high demand across all sectors, such as finance, consulting, manufacturing, pharmaceuticals, government and education.

 

The ability to pay attention to detail, communicate well and be highly organised are essential skills for data analysts. They not only need to understand the data, but be able to provide insight and analysis through clear visual, written and verbal communication.

 

Some responsibilities of a data analyst includes:

  • Developing records management processes and policies
  • identify areas to increase efficiency and automation of processes
  • set up and maintain automated data processes
  • identify, evaluate and implement external services and tools to support data validation and cleansing
  • produce and track key performance indicators
  • develop and support reporting processes
  • monitor and audit data quality
  • liaise with internal and external clients to fully understand data content
  • gather, understand and document detailed business requirements using appropriate tools and techniques
  • design and carry out surveys and analyse survey data
  • manipulate, analyse and interpret complex data sets relating to the employer’s business
  • prepare reports for internal and external audiences using business analytics reporting tools
  • create data dashboards, graphs and visualisations
  • provide sector and competitor benchmarking
  • mine and analyse large datasets, draw valid inferences and present them successfully to management using a reporting tool

 

In this course we will perform some task of a Data Analyst  using Python ,Excel, Tableau, SQL, and  Power BI.  We will connect to a variety of data sources, perform  data transformation ,cleaning and  exploration . We will create dashboards to visual data

Show More

Course Content

Class 01 – Introduction to Power BI | Data Sourcing and Warehousimg | Difference b/w Data Mart, Data Lake, Data Warehouse | Installing Microsoft Power BI | Excel vs Power BI | Exploring Data Sources | Data Types | Introduction of Power Query

  • Data Analyst (Batch-08) – Session 01
    02:36:12

Class 02 – Exploring Data Source (Web, SQL Server) | Text Tools (Extract, Split Columns, Merge Columns Format Data) | Duplicate Column | Replace Values | Parse Data (XML, JSON) | Views (Column Distribution, Profile, Quality) | Numeric Tools (Statistics, Standard, Trigonometry, Rounding, Information) | Handling Errors

Class 03 – Change Type with Locale | Date Tools (Month Name, Year, Start of Year, Start of Week, Name of Day, Age) | Conditional Column | Index Column | Merge Queries | Append Queries | Grouping Data | Line Chart (Zoom Chart, Gridlines, Shade Color, Forecasting, Trend Line)

Class 04 – Understanding of Database Management Systems (DMS).| Tables | Primary & Foreign Keys | Relationship Cardinality | Relationships (One-to-Many) | Star and Snowflake Schemas | Real Life E-Commerce Sample Database (Datatypes)

Class 05 – Data Modeling and it’s Practical Implementation | Identifying Primary Keys | Relationships between Tables | Custom Layout Examples of Star and Snowflake Schema | Bi-Directional Flows | Active and Inactive Relationship | Connecting Multiple Fact Tables (Through Dimensions) | Hide Columns in Model View | Creating Hierarchies

Class 06 – DAX Measures and Conditional Columns | What is Data Analysis Expression (DAX) | Difference between DAX and M-Code | Conditional Columns | DAX Measures (SUM, AVERAGE, COUNT, DISTINCTCOUNT, DIVIDE) | Logical Functions (IF, SWITCH)

Class 07 – DAX Measures and Conditional Column (ALL, FILTER) | Iterators Functions (SUMX,MAXX,MINX) | Time Intelligence (DATESYTD, DATEADD, DATEINPERIOD)

Class 08 – Creating Dashboard: Map Visuals | Table Visuals | Donut Chart | Top N Filtering | Real Life Scenarios Discussion

Class 09 – Gauge Chart |.Slicers | Visual Filters | Styling of Filters | Line Charts | Bookmarks and Buttons | Edit Interactions

Class 10 – Navigation buttons I Slicer panel creation Manage I View roles Discussed the importance of roles Field Parameters

Class 11 – AI Visuals | Key Influencers | Decomposition tree | Q&A | Narrative | Anomalies

Class 12 –

Class 13 –

Class 14 –