AIGig

Business Intelligence  What is Business Intelligence? BI(Business Intelligence) is a set of processes, architectures, and technologies that convert raw data into meaningful information that drives profitable business actions Why BI  Providing BI ready Data  Data Driven decisions Comparisons of multiple vendors  Risk Analysis  Controls on business  Business Opportunities Implementing an Effective Strategy Competitive market advantage Long-term stability What is BI  To understand the structure and the dynamics of the organization in which a system is to be deployed. To understand current problems in the target organization and identify improvement potentials. To ensure that the customer, end user, and developers have a common understanding of the target organization . Data Requirement  Trend Data  Data files  Current Data  Real-time Data  Department wise data  Data Mining  ...

Data Manipulation techniques using Pandas  Data Manipulation using Pandas  Boolean Indexing  Apply function  Impotting missing files  Pivot table  Multi Indexing  Crosstab  Merger DataFrames Sorting DataFrames Plotting (Boxplot & Histograme) Cut function for Binning  Nominal Data coding  Iterating over rows of a DataFrame

Algorithms   That you must know for your Data Scientist career  Following Algorithms are very important  K-means  Linear Regression. Logistic Regression. Decision Tree. SVM. Naive Bayes. kNN. K-Means. Random Forest. Dimensionality Reduction Algorithms  Gradient Boosting Algorithms  XGBoost LightGBM Catboost

Data Visualization  Data visualization is process of making clear picture of data.

Data Analysis With Excel  How to use excel for Data Analysis ? Methods to use   Sort :- Sorting your data from multiple datasets.  Filter :- Filter for specified value  Conditonal Formatting:- Arranage or highlight data using the condition format. Chart:- Visualize your data  Pivot Tables:- Prepare data with required fields Tables:- Table to show the proper information  What-If Analysis:- Format cells using what if  Solver :- Setting targeting requirement and using the function  Analysis ToolPak:- Many functions used for data analysis Histogram,Corelation,Varience etc.

Data Mining  What is Data Mining? Data Mining is defined as extracting information from huge sets of data. In other words, we can say that data mining is the procedure of mining knowledge from data. The information or knowledge extracted so can be used for any of the following applications: • Market Analysis • Fraud Detection • Customer Retention • Production Control • Science Exploration Used for  Market Analysis Fraud Detection Customer Retention Production Control Science Exploration Market Analysis  Customer Identifying :- Helps to find nature of customer what sort of thing customer likes to buy and how oftly he buys Requirement Analysis :- Helps to determing customer requirements Audience Targeting :- can easily target Audience from the data mined. Purchasing Behaviour :- How customer prefers to buy things and When,Where and How Risk Management Finiance Decision making :- Helps to BD to Take financial decisions from the...

Data Analysis What is Data Analysis ?  Data analysis is a process of Inspecting ,Cleansing,Modeling and Transforming the data . Inspecting Data :- Inspecting is done in data analysis to look for useful information and data to use for decision making and improvement of data.  Cleansing Data :- Cleansing means correcting information and looking for inaccurate columns and correcting them Modeling of Data :- Modeling is important part of data analysis in modeling many thing are done like Data Visualisation,Data mapping,Data Gathering etc in next part will be discussed. Transforming Data :- Transforming data means getting raw data and transforming it in information and useful work. Data Analytics Tools  1)Tableau Public Tableau  is simple data analytics tool intriguing insights through data visualization.it Public’s million row limit Uses Publish interactive data visualizations to the web  No programing  Can be embed i...