Posts

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…

Comparison of Power BI Service vs. Power BI Report Server vs. SQL Server Reporting Services

Image
Comparison of Power BI Service vs. Power BI Report Server vs. SQL Server Reporting Services Following is a summary of the key feature differences available when deploying to the cloud-based Power BI Service vs. the on-premises report deployment options (this is not an exhaustive list of all features). SQL Server Reporting Services (SSRS) is included only for comparison to the Power BI Report Server, as SSRS is beyond the scope of this whitepaper.


Feature/Capability Power BI Service Power BI Report Server June 2017 SQL Server  2017 Reporting Services
Publish and View Reports: Publish and view RDL (Reporting Services paginated report)
Publish and view PBIX (Power BI report)
Publish and view XLSX (Excel workbook)

Rendering of custom visuals utilized in a PBIX
Use of native mobile applications (iOS, Android, Windows)

Why SharePoint Online is a much smarter choice than SharePoint On-Premise!

Security, is way tighter in SPO infact – and some features do not even exist in SP On-Premise.
For instance, with SPO:
1.You get the ADFS integration – which means, you can take advantage of the ADFS features & security policies, location based control for SPO as well 2.RMS – Rights Management Services – Azure RMS – is pre-configured in SPO and supports file types such as MS Office, PDF files, Images too – and all you need is the Azure Information Protection Client to view the protected files 3.You get DLP (Data Loss Prevention) which is only available with SPO and I have created a presentation for this here – Have a look and using this, we can prevent confidential content such as documents containing patents, SSN numbers or SWIFT Codes or IP Addresses can be protected from going out 4.SPO Content has multiple times encrypted and hence, the content is way secure than you can imagine 5.On top of it, you can even prevent SPO Sites from being accessed through certain IP Addresses, prevent …

10 Skills Every SharePoint Developer Needs

This blog post guides you through the essential skills for a successful SharePoint developer. Great SharePoint developers know how to use scripting, design, and drafting tools. They have knowledge of out of the box features that don’t necessarily need customization. This list includes the addition of a few personal attributes too. 1. KNOW THE OUT OF THE BOX TOOLS AVAILABLE TO A SHAREPOINT DEVELOPER This is the skill required above all else. You can be interviewing an amazing .NET developer who really knows their stuff, but never worked specifically in SharePoint. Unfortunately hiring him would be a huge fail on your part. SharePoint development is an odd beast and even someone who has top notch skills in all of the below mentioned areas, but no real understanding of SharePoint will fall on their face when attempting to tackle your project. Find someone who can talk SharePoint with you and prove experience using the following Windows-specific tools: 1.Out of the box features for creating w…

Multi Factor Authentication, Conditional Access for Power BI

There is always a discussion on protecting Power BI access, enabling MFA, conditional access etc. This is very much possible. Please refer this article. https://powerbi.microsoft.com/en-us/blog/secure-and-audit-power-bi-in-your-organization/ I have attached a PPTwith screenshots of how this works (infact, I have taken it from iGrid’s Azure Subscription) Using certain configuration, you can even block access for users, when they are not at work. Infact, you can have such a configuration done for every O365 product.
You would require Azure AD Premium P1 for this and different plans are here: https://www.microsoft.com/en-us/cloud-platform/azure-active-directory-pricing This could approximately cost $6/user/month.