Business Analytics Masters with 3 month Internship

Learn the power of using powerful visualization tools such as PowerBi and Tableau alongside advanced excel coupled with the most important fundamentals of Python

Start Date: 27th February 2021
Class Timings: 10:00 AM to 12:00 PM (IST) Saturday - Sunday
Doubt Clearing Session: 3:30 PM IST to 5:30 PM IST (IST) Monday

Course Overview

This is a detailed Business analytics course where you will learn Python Core, PowerBi, Tableau, advanced Excel and statistics to give you the most competitive edge.

What you'll learn
  • Python
  • PowerBI
  • Tableau
  • Advanced Excel
  • Statistics
Requirements
  • Laptop
  • Stable internet connection

Course Curriculum

  • Install setup and overview
  • Ipython /Jupiter Notebook overview.
  • Intro to NUMPY.
  • Creating Arrays.
  • Using Arrays and Scalar.
  • Indexing Arrays.
  • Arrays transposition.
  • • Universal arrays function.
  • Arrays processing.
  • Array input and output.
  • Series.
  • Data frames.
  • Index Objects.
  • Re index.
  • Drop entry.
  • Selecting entries.
  • Data alignment.
  • Rank and Sort.
  • Summary statistics.
  • Missing data.
  • Index Hierarchy.
  • • Reading and writing text files.
  • JSON with Python.
  • HTML with Python.
  • Microsoft Excel files with Python.
  • Merge.
  • Merge on Index.
  • Concatenate.
  • Combining Data Frames.
  • Reshaping.
  • Pivoting.
  • Duplicates in DataFrames
  • Mapping.
  • Replace.
  • Rename index.
  • Binning.
  • Outliners.
  • Permutation.
  • GroupBy on DataFrames
  • GroupBy on Dict and Series.
  • Aggregation.
  • Splitting, Applying and combining.
  • Cross Tabulation.
  • Installing Seaborn.
  • Histograms.
  • Kernel Density estimate plots.
  • Combining plot styles.
  • Box and Violin plots.
  • Regression Plots.
  • Heat maps and clustered matrices.
  • Introduction to SQL with Python.
  • SQL SELECT, DISTINCT, WHERE, AND & OR.
  • • SQL WILDCARDS, ORDER BY, GROUP BY, and Aggregate Functions.
  • Introduction.
  • ER Diagram.
  • Schema Design.
  • Normalization.
  • SQL SELECT statement.
  • SQL SELECT using common functions.
  • SQL JOIN overview.
  • INNER JOIN.
  • LEFT JOIN.
  • RIGHT JOIN.
  • FULL JOIN.
  • SQL best practice.
  • INNER JOIN Advanced.
  • INNER JOIN and LEFT JOIN combo.
  • SELF JOIN.
  • JOINS and AGGREGATION Subqueries.
  • Sorting.
  • Independent Subqueries.
  • Co related Subqueries.
  • Analytic function.
  • Set operations.
  • SQL views.
  • Create a view.
  • Create a view using DDL.
  • SQL insert Advanced Technique.
  • Insert to create table.
  • INSERT to new data on existing table 1.
  • INSERT to new data on existing table 2.
  • INSERT to new data on existing table 3
  • INSERT to new data on existing table 4.
  • SQL update Advance technique and TCL.
  • SQL delete and TCL.
  • SQL constraints.
  • SQL aggregations.
  • SQL programmability.
  • SQL query performance.
  • SQL Extras.
  • Data wrangling with Excel
  • Microsoft Excel fundamentals.
  • Entering and editing texts and formulae.
  • Working with basic Excel functions.
  • Modifying an Excel worksheet.
  • Formatting data in an excel worksheet.
  • Inserting images and shapes into an Excel worksheet.
  • Creating Basic charts in Excel.
  • Printing an Excel worksheet.
  • Working with an Excel template.
  • Working with an excel list.
  • Excel list function.
  • Excel data validation.
  • Importing and exporting data.
  • Excel pivot tables.
  • Working with excels PowerPivot tools.
  • Working with large sets of Excel data.
  • Conditional function.
  • Lookup functions.
  • Text based functions.
  • Auditing and Excel worksheet.
  • Protecting Excel worksheets and workbooks.
  • MasteringMasteringExcelExcel"What"What--if?"if?"Tools?Tools?
  • Automating Repetitive Tasks in Excel with Macros.Automating Repetitive Tasks in Excel with Macros.
  • Macro Recorder Tool.Macro Recorder Tool.
  • Excel VBA Concepts.Excel VBA Concepts.
  • Advance VBA.Advance VBA.
  • Preparing and Cleaning Up Data withPreparing and Cleaning Up Data withVBA.VBA.
  • VBA to Automate Excel Formulas.VBA to Automate Excel Formulas.
  • Preparing Weekly Report.Preparing Weekly Report.
  • Working with Excel VBA User Forms.Working with Excel VBA User Forms.
  • Importing Data from Text Files.Importing Data from Text Files.
  • Descriptive Analytics.
  • Inferential Statistics.
  • Hypothesis Test 1 & 2.
  • Covariance
  • Correlation.
  • Regression.
  • Conjoint & Discriminant Analysis.
  • Discrete Uniform Distribution.
  • Continuous Uniform Distribution.
  • Binomial Distribution.
  • Poisson Distribution.
  • Normal Distribution.
  • Sampling Techniques.
  • T Distribution.
  • Hypothesis Testing and Confidence Intervals.
  • Chi Square Test and Distribution.
  • Bayes Theorem.
  • Talking about Business Intelligence.
  • Tools and Methodologies used in BI.
  • Why Visualization is getting more popular.
  • Why Tableau?
  • Gartner Magic Quadrant of Market Leaders.
  • Future business impact of BI.
  • Let's Explore…
  • Tableau Products.
  • Tableau Architecture.
  • BI Project Execution.
  • Tableau Installation in local system.
  • Introduction to Tableau Prep.
  • Tableau Prep Builder User Interface.
  • Data Preparation techniques using Tableau Prep Builder tool
  • How to connect Tableau with different data source.
  • Visual Segments.
  • Visual Analytics in depth.
  • Filters, Parameters & Sets.
  • Tableau Calculations using functions.
  • Tableau Joins.
  • Working with multiple data source (Data Blending).
  • Building Predictive Models.
  • Dynamic Dashboards and Stories.
  • Sharing your Reports.
  • Tableau Server.
  • User Security.
  • Scheduling
  • PDF File.
  • JSON File.
  • Spatial File.
  • Statistical File.
  • Microsoft SQL Server.
  • Salesforce
  • AWS
  • Azure.
  • Google Analytics.
  • R
  • Python
  • Hadoop
  • OneDrive
  • Microsoft Access.
  • SAP HANA.
  • SharePoint.
  • Snowflake.
  • Subject
  • Planning.
  • Pen & Paper approach.
  • Tools
  • Color theme.
  • Shapes
  • Fonts
  • image Selection.
  • text position.
  • visual placing.
  • Story layout & design.
  • Dashboard planning.
  • Power BI introduction and overview.
  • Key Benefits of Power BI.
  • Power BI Architecture.
  • Power BI Process.
  • Components of Power BI.
  • Power BI Building Blocks.
  • Power BI vs other BI tools.
  • Power Installation.
  • Overview of Power BI Desktop.
  • Data Sources in Power BI Desktop.
  • Connecting to a data Sources.
  • Query Editor in Power BI.
  • Views in Power BI.
  • Field Pane.
  • Visual Pane.
  • Custom Visual Option.
  • Filters.
  • Introduction to using Excel data in Power BI.
  • Exploring live connections to data with Power BI.
  • Connecting directly to SQL Azure, HD Spark, SQL
  • Server Analysis Services/ My SQL.
  • Introduction to Power BI Development API.
  • Import Power View and Power Pivot to Power BI.
  • Power BI Publisher for Excel.
  • Content packs.
  • Introducing Power BI Mobile.
  • Power Query Introduction.
  • Query Editor Interface.
  • Clean and Transform your data with Query Editor.
  • Data Type.
  • Column Transformations vs Adding Columns.
  • Text Transformations.
  • Cleaning irregularly formatted data Transpose.
  • Date and Time Calculations.
  • Advance editor: Use Case.
  • Query Level Parameters.
  • Combining Data Merging and Appending.
  • Data Modelling.
  • Calculated Columns.
  • Measures/New Quick Measures.
  • Calculated Tables.
  • Optimizing Data Models.
  • Row Context vs Set Context.
  • Cross Filter Direction.
  • Manage Data Relationship.
  • Why is DAX important?
  • Advanced calculations using Calculate functions
  • DAX queries.
  • DAX Parameter Naming.
  • Time Intelligence Functions.
  • Types of visualization in a Power BI report.
  • Custom visualization to a Power BI report.
  • Matrixes and tables.
  • Getting started with color formatting and axis properties.
  • Change how a chart is sorted in a Power BI report.
  • Move, resize, and pop out a visualization in a Power BI report.
  • Drill down in a visualization in Power BI.
  • Drill Through.
  • Histograms
  • Basic Area chart.
  • Combo Chart in Power BI.
  • Customize visualization title, background, and legend.
  • Doughnut charts in Power BI.
  • Scatter Charts in Power BI.
  • Funnel charts in Power BI.
  • KPI Visuals.
  • Radial Gauge charts in Power BI.
  • Bookmarks in Power BI.
  • Slicers in Power BI.
  • Filters
  • Report Level Parameters.
  • Z Order.
  • Waterfall charts in Power BI.
  • Create a Power BI dashboard.
  • Dashboard tiles in Power BI.
  • Pin a tile to a Power BI dashboard from a report.
  • Pin an entire report page to a Power BI dashboard.
  • Data alerts in Power BI service.
  • Add an image, text box, video, hyperlink or web code to your dashboard.
  • Configuring a Dashboard.
  • Power BI Q&A.
  • Display a dashboard tile in Focus mode.
  • Power BI embedded.
  • Row Level Security in Power BI.
  • Report Server Basics.
  • Refresh a dataset created from a Power BI Desktop file local.
  • Refresh a dataset created from a Power BI Desktop file cloud.
  • Web Portal.
  • Paginated Reports.
  • Data Gateways.
  • Scheduled Refresh.
  • Resources (Rest API/ SOAP API’s/ URL Access).
  • R Integration in Power BI Desktop.
  • R Powered Custom Visuals.
  • Creating R visuals in Power BI.
  • R Visuals in Power BI Service.
  • R Scripts Security.
  • Creating visual using Python.
5.00 out of 5.0
1 Star 0.0%
2 Star 0.0%
3 Star 0.0%
4 Star 0.0%
5 Star 100.0%
Amit Bose

Having 11+ years of experience in Data Analytics ,Power BI, Tableau, SQL, Excel. Worked in various product and service based Company. Having an experience of 4+ years in educating people and helping them to make a career transition.

Reviews

Syed Rehan
March 16,2021
5.00

" Great content and lot of exercises + assignments to practice. #HappyLearning :) "

Nitesh Kumar
February 25,2021
5.00

" When will this course start? "

Ayush Bansal
February 25,2021
5.00

" this week course start or not or we have to ait for somemore week "

Submit Reviews

You can not rate this course before login

Join Thousand of Happy Students!

Subscribe our newsletter & get latest news and updation!