Power BI

Power BI Security White Paper - https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-power-bi-security/

Power BI YouTube Channel (Great Learning Source) - https://www.youtube.com/user/mspowerbi

Guy in a Cube: https://www.guyinacube.com/

Power BI Gateways - https://powerbi.microsoft.com/en-us/documentation/powerbi-personal-gateway/

Pricing and Key Differentiation between free and Pro - https://powerbi.microsoft.com/en-us/pricing/

Administrating Power BI in your Organization: https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-administering-power-bi-in-your-organization/

T4 Template

T4 templates are build-in feature for Visual Studio IDE.  Here is the video to get started.

https://www.youtube.com/watch?v=XK17iNvJqQs

T4 can be used in many areas.  Recently I am working on big data solutions, in which the scripting language does not provide looping mechanism.  The T4 template become handy to bridge the gap and avoid spinning up multiple jobs to process every day data.

Learning from CorpNet support help desk

Here is my learning from our Support Help desk for my CorpNet related issues.

RAS connection not working
Many time the RAS issues are due to IP cache, try the following commands to reset the IP 

• netsh int ip reset
• netsh winsock reset
• ipconfig/flushdns             
• ipconfig/flushdns
• nbtstat -R
• nbtstat -RR
• ipconfig/registerdns 

Unable to access local sites

If the group policy not updated you may have diff access issues.  By running gpupdate /force from elevated problem, you can make sure the gp is updated.

User autoenrollment is triggered by the Winlogon process (interactive logon with CTRL+ALT+DELETE keys) or at Group Policy refresh intervals. Normally, User Group Policy is refreshed at logon and Machine Group Policy is refreshed at machine reboot. Group Policy may be manually refreshed using the gpupdate.exe tool that is included in Windows XP.

https://technet.microsoft.com/en-us/library/cc728032(v=ws.10).aspx

Infographic tools

1. Easel.ly
2. Piktochart
3. Infogr.am
4. Visual.ly
5. InFoto Free
6. Venngage
7. Dipity
8. Get About
9. Vizualize: Visualize your resume
10. Google Developers : Google Chart

Data Science Cources

If you are planning to learn Data Science Space, here is the list of MOOC (Massive Open Online Courses) from edX.

1. From Indian Institute of Technology Bombay
1. Foundations of Data Structures
2. From University of California, Berkeley
1. Introduction to Apache Spark
2. Big Data Analysis with Apache Spark
3. Distributed Machine Learning with Apache Spark
3. From Microsoft
1. Data Science Essentials
2. Implementing Predictive Solutions with Spark in Azure HDInsight
3. Implementing Real-Time Analysis with Hadoop in Azure HDInsight
4. Principles of Machine Learning
5. Processing Big Data with Azure HDInsight
4. From Cornell University
1. Wiretaps to Big Data: Privacy and Surveillance in the Age of Interconnection
2. Machine Learning for Data Science and Analytivs
5. Hong Kong Polytechnic University
1. Knowledge Management and Big Data in Business

Cross Join

Recently met with a problem, where in I need to lookup a table using LINQ query where the JOIN clause is not supporting non-equi joins.  The Cross Join came as handy and helped.  Here is the sample SQL query which unit tested the same.

 

DROP TABLE BucketList
GO
CREATE TABLE BucketList
(
    StartNum INT,
    EndNum INT,
    Bucket VARCHAR(20)
)

INSERT INTO BucketList values
( 1,10,'[01-10]')
,( 11,20,'[11-20]')
,( 21,30,'[21-30]')
,( 31,40,'[31-40]')

drop TABLE #T1
go
CREATE TABLE #T1
(
    IP INT,
    Label VARCHAR(40)
)

INSERT INTO #T1 VALUES
(4,'Four')
,(9,'Nine')
,(34,'Thirty four')
,(44,'FortyFour')
GO

SELECT StartNum, EndNum, Label, Bucket
FROM #T1
CROSS JOIN BucketList
WHERE IP >= StartNum AND IP <= EndNum

Windows Calculator

Do you know Windows Calculator can do more than simple calculators.  Probably you may used different views of calculators like Standard, Scientific, Programmer and Statistics.  But do you know you can do more with Windows Calculator!!

Unit Conversion

Date Calculation (Even Excel cannot do this as simple as it is!!)

Lease Calculation

Fuel Calculation