Showing posts from June, 2019

Six qualities of a great Data Scientist

What does it take to be a great data scientist?  Some of these you undoubtedly know without looking, but others may surprise you. These six hard and soft skills are not just things to look for in a data science hire, but are also things to cultivate in yourself to prepare for a successful and fulfilling career in data science.
1. Statistical thinking Data scientists are professionals who turn data into information, so statistical know-how is at the forefront of our toolkit. Knowing your algorithms and how and when to apply them is arguably the central task to a data scientist's work. However, to do this well can be an art and a science.
A good data scientist can model any data he is given and implement a toolbox full of algorithms to make statistically-informed predictions and recommendations. A great data scientist can smell something 'fishy' in the results she gets, senses that he needs to ask the client or stakeholder a few more questions before retreating …

Excel Key Features to learn for a Data Analyst

Learning Advanced Excel - Needed to Explore Data, understand patterns & themes on the data...
Below will help you become a good Data Analyst on Excel What is Latest Excel Version Maximum Rows & ColumnsCalculated Columns Casting / Conversion of Data TypesEspecially working Text to Numbers, Extracting Year, Month, Date from a single datetime or date column Converting / changing / bringing a single time zone for multiple timezone data String operations - Extracting only a portion of your value Statistical Functions in ExcelBanding a value available in a single column Pivot Tables - SO IMPORTANT and need to go deep into various features available on a Pivot TablePivot ChartsUsing Slicers with Pivot TablesUsing Filters with Pivot TablesUsing Sorting inside Pivot TablesMoving around Rows & Columns and understanding themes in your dataVLookupHLookupWhen to use LookupsBringing values / columns from multiple excel sheets into a single sheet Writing basic macros to transform values …

Learning Power BI - Keywords, Key Topics to learn and useful links

1) Keywords - you should know what each of these mean, when you learn PBI.
Power BI Licensing: Free, Pro, PremiumPower BI Cloud and Power BI On-Premise (Power BI Report Server)Power BI Desktop and how to use itWays to bring in data - Import Data, Direct Query and Live
What is SSAS Tabular and why PBI with SSAS Tabular model is great combinationSize limitations when you do Import Data
# of times you can refresh data in a day  - when you do Import DataBuilding Blocks of PBI - DataSets, Dashboards, Reports, Tiles, VisualizationsSlicersFilters and difference with SlicersWhat is DAX and DAX Expressions Custom ColumnsCustom Measures and difference with Custom ColumnsData Modeling within PBI Desktop
Certain basic business expectations - how do you do it in PBI - Bringing in YTD, MTD, Doing Trends, Comparing YoY, MoMUsing MapsUsing InfoGraphics
Custom Visuals and how to use themSQL Server latest version
SQL Server various Editions
Writing basic SQL QueriesUsing SQL Commands in PBIUsing SQL S…